Introduction: In this blog, how multiple Production Environment works. Prerequisites: Microsoft Dynamics Business Central Yammer subscription( to refer the yammer links ) Books & References: https://www.yammer.com/dynamicsnavdev/threads/360051585302528 Demonstration / Solution: 1. Creation of multiple Production Tenant and Login: Creating a Production Environment with different Localization When system is Preparing a Production Environment When you Login in https://businesscentral.dynamics.com, the system asks you to select the environment to log in If you use the https://businesscentral.dynamics.com/<PRODUCTION ENVIRONMENT NAME>, it directly takes you to the respective environment. 2. How licensing works for multiple Production Tenant.: As per Licensing for October 2019 which states that only One Production Tenant is available. Business Central October 2019 Licensing Guide –  Default Subscription Capacities After a conversation back and forth it was clarified that the licensing will be actually updated by April 2020 Wave 1 Release Refer: https://www.yammer.com/dynamicsnavdev/threads/360051585302528 Taking a level further as per discussion with, we, at CloudFronts have envisioned using multiple localization Production Tenant and then consolidate the Financial Reports. 3. How to leverage Intercompany – multiple localization Production Tenant and then consolidate the Financial Reports: For now, the consolidation of multiple legal entities in multiple Production Tenant is in backlog with no ETA provided. Let us see if we can do it manually in some way. Conclusion: Thus, this blog was just to give information about multiple Production Environment deployments, Default Subscription Capabilities and Intercompany consolidation of multiple production environments. I shall try to manually consolidate multiple production environments in my upcoming blogs.

Inventory Posting Group: Use to specify the type of Inventory or group the item. Inventory Posting setup: Use to combine Inventory Posting group with location codes. Each combination is then mapped to the inventory accounts, WIP account, and other variance accounts relating to inventory in the chart of accounts. Steps: Set up Inventory Posting Group In the search option, enter the Inventory Posting Group and then choose the related link. Select New. In the Code field, type a unique identifier. In the Description field, type description of Inventory Posting Group.   Steps: Set up Inventory Posting Setup In the search option, enter Inventory Posting Setup and then choose the related link. Select New to insert a new line. In Location Code Field, select the relevant location to combine with the inventory posting group. Select the relevant inventory posting group in the Inventory Posting Group Code field. In each relevant account field, enter the G/L accounts that will be used to post transactions to: Inventory Account: Specifies the number of the G/L account that item transactions with this combination of Location and Inventory Posting group posted to. Inventory Account (Interim): Specifies the number of the G/L account to which to post the transactions with the expected cost for items in this combination. WIP Account: Specifies the general ledger account number to which to post transactions for items in WIP inventory in this combination. Material Variance Account: Specifies the number of general ledger account to which Material variance transactions for items in this combination. Capacity Variance Account: Specifies the number of general ledger account to which to post capacity variance transactions for items in this combination. Subcontracted Variance Account: Specifies the number of general ledger account to which to post subcontracted variance transactions for items in this combination. Overhead Variance Account: Specifies the number of general ledger account to which to post capacity overhead variance transactions for items in this combination. Overhead Variance Account: Specifies the number of general ledger account to which to post Manufacturing overhead variance transactions for items in this combination.   Steps: Assign Inventory Posting group to Item In the search option, enter Items and then choose the related link. Open the Item card Expand the Cost & Posting FastTab, in the Inventory Posting Group field, enter the appropriate posting group. Conclusion: Inventory posting group and setup use to posts entry to the G/L account specified for the combination of inventory posting group and location code linked to the item line entry.

There are so many different ERP systems in the world. ERP simply means an enterprise resource planning system. While there is stiff competition, Microsoft Dynamics NAV integration is one of the best ERP systems that companies love using. It is because of numerous features that it offers to its clients. One of the reasons why people like it is because this ERP system allows you to sync their ERP with all other systems out there with ease. There is no need to touch any buttons to make this happen. The other name for Microsoft Dynamics NAV is Microsoft Dynamics 365 Business Central. Now, this is one of the many products that are part of the vast Microsoft Dynamics family. Introduction: In this blog, I will demonstrate how to Undo and then Redo Quantity Posting on a Posted Return Shipments in Microsoft Dynamics NAV / Business Central. This functionality is useful if user ships the wrong quantity or selected the wrong item for Purchase Return Order. Pre-requisites: Microsoft Dynamics NAV Microsoft Dynamics Business Central Demonstration: NOTE: You cannot undo a posting if purchase credit memo is posted. 1. In the search option, enter Posted Purchase Return Shipment and then choose the related link. 2. Open the Posted Purchase Return Shipment that you want to undo. 3. Select the Posted Purchase Return Shipment Lines that you want to undo.   4. In Lines, click on Function button and choose to Undo return shipment action. 5. Choose Yes in pop up box. 6. A corrective line inserted under the selected Return Shipment Line. 7. The Return Quantity Shipped field on the related Purchase Order will be set blank once undo receipts. 8. Open the return order in question, and then choose the Reopen action. 9. Correct the entry in the Quantity field and Post the Purchase Return Order again. Conclusion: The functionality helps the user to reverse the Purchase return shipment so the user can Post Purchase Return Order with correction.

Introduction: In this blog, I will demonstrate how to undo a Quantity Posting on a Posted Purchase Receipt in Microsoft Dynamics NAV / Business Central. This functionality is useful if the user receives the wrong quantity or selected the wrong item for the Purchase order. Pre-requisites: Microsoft Dynamics NAV Microsoft Dynamics Business Central Demonstration: NOTE: You cannot undo a posting if the purchase invoice is posted. 1.    In the search option, enter Posted Purchase Receipts and then choose the related link. 2.    Open the Posted Purchase Receipts that you want to undo. 3.    Select the Posted Purchase Receipt Lines that you want to undo. 4.    In Lines, click on Function button and choose Undo receipt action. 5.    Choose Yes in pop up box. 6.    A corrective line inserted under the selected receipt line. 7.  The Quantity Received field on the related Purchase Order will be set blank once you undo the receipts. Conclusion: The functionality helps the user to reverse the Purchase receipts so the user can post purchase order with correction.

Introduction: In this blog, I aim to provide how to set Mandatory Dimensions on Items, Customers, Vendors, and G/L Accounts and how to optimize this process using Configuration package. Pre-requisites: Microsoft Dynamics NAV. Microsoft Dynamics Business Central. Understanding of Dimensions in NAV / BC Theory: Automatic Dimensions can be added for the G/L Accounts, Customers, Vendor, and Items. The Value Posting can be selected as per the below Table. Value Posting Explanation Blank No posting restriction.Transactions can be posted with any dimension value or without a dimension value. Code Mandatory Any dimension value for the given dimension can be added. If dimension value is blank then NAV / BC will throw an error Same Code Only a single dimension value defined in Default Dimension can be used while posting. No Code Dimensions must not be specified on the transactions.   This also implies that you can add the Default Dimension, No-Dimension, Mandatory Dimension and Manual Dimension only when needed using the Default Dimension functionality.   Solution: 1. Apply Mandatory Dimension on Items: Go to Items > Select the Item and Open Card Page > Click on Dimensions Action. In the Default Dimension Table, Table No. for Items Table is 27 which is automatically selected. The value posting is also selected in the table based upon what option is selected. 2. Apply Mandatory Dimension on Customers: Go to Customers > Select Customer and Open Card Page > Click on Dimensions Action In the Default Dimension Table, Table No. for Customer Table is 18 which is automatically selected. The value posting is also selected in the table based upon what option is selected. 3. Apply Mandatory Dimension on Vendors: Go to Vendors > Select Vendor and Open Card Page > Click on Dimensions Action In the Default Dimension Table, Table No. for Vendor Table is 23 which is automatically selected. The value posting is also selected in the table based upon what option is selected. 4. Apply Mandatory Dimension on G/L Accounts: Goto Chart of Accounts > Select the G/L Account and Open the Card Page > Click on  Dimensions Action. In the Default Dimension Table, Table No. for Chart of Accounts Table is 15 which is automatically selected. The value posting is also selected in the table based upon what option is selected. NOTE: You can give multiple Mandatory Dimensions as well 5. Using Configuration Package: In Configuration Package, add the Table 352 Default Dimension and Export the Excel. You can add the dimensions referring to the points 1-4 and insert you data in the Excel. Import the Excel Package and Apply Data. Conclusion: Applying manually for each Master Record can be tedious and time consuming. In this blog I tried to add few sample records so that we can take help of this samples to create our conditions and insert data into Excel and apply it on all the Master Records.

This functionality helpful to correct posted Sales invoice if user make mistake or want to do any changes. You cannot correct posed Sales invoice which are partially or fully paid. In search bar enter Posted Sales Invoice and chose the related link. Select and open Posted Sales Invoice which you want to correct Click on correct button on Posted Sales Invoice form. Once you click on correct then you will get below pop up. Choose yes to continue. New Sales Invoice with same information will be created. Make the changes whichever are required and click on post button to post Sales invoice. In Posted Sales Invoices form, you can check new posted sales invoice. Choose Show Corrective Credit Memo to view the posted Sales credit memo that voids the initial posted Sales invoice.

Transfer order mainly use for Transfer inventory from one location to another location. Below are the steps to create transfer Order In the Search box, enter Transfer Orders, and select the link Click on New button to create new transfer order. Select the Location in Transfer from Code field from where you want to ship the Inventory Select the Location in Transfer to Code field from where you want to receive the Inventory. Direct Transfer: If select yes then the transfer does not use as in-transit location. When you transfer directly, the Qty. to receive field will be locked with the same value as the quantity to ship. Select the Item, quantity on Transfer order lines. If Direct transfer is no then Select the Location in In-Transit Code field which is used for mainly material is shipped from one location but not received in another location. On Action tab, click on post button to ship the Inventory from one location. Select ship in message Box and click on OK. You can check Quantity which are shipped in Quantity Shipped field. Then again click on Post button to receive the inventory in another location. Select Receive in message box and click on OK. You can check transferred shipment in Posted Transfer Shipments. You can check transferred receipts in Posted Transfer Receipts. Conclusion:  Transfer orders involve posting items as shipped from one location and posting them as received at the other location.  

There might be a case where the vendor sends a single invoice for multiple purchase orders receipts, in this scenario we will see how to post one invoice for multiple purchase receipts of the same vendor. You can use Combine Receipt function to Invoice more than one purchase receipt. In search option, enter Purchase order and then choose related link Click on New button to create Purchase Order. Enter all necessary information on Purchase order which are required and click on Post button. Select receive and choose OK button to post purchase receipt. Repeat steps from 1 to 4 to create multiple Purchase order and post purchase receipt. Now in search option, enter Purchase Invoices and choose related link. Click on New button to create Purchase Invoice. Select Vendor in Vendor Name field. On the LinesFastTab, choose the Get Receipt Lines. Select multiple receipt lines that you want to include in the invoice and choose the OK button. In Line section, You can see the added purchase receipt lines. To post the invoice, choose the Post action.    

There might be a case where the company sends a single invoice for multiple Sales orders shipments, in this scenario we will see how to post one invoice for multiple sales shipment of the same customer. You can use Combine Shipment function to Invoice more than one sales shipment. In search option, enter Sales order and then choose related link. Click on New button to create Sales Order. Enter all necessary information on Sales order which are required and click on Post button. Select ship and choose OK button to post Sales Shipment. Repeat steps from 1 to 4 to create multiple Sales order and post sales shipment. Now in search option, enter Sales Invoices and choose related link. Click on New button to create Sales Invoice. Select Customer in Customer Name field. On the LinesFastTab, choose the Get shipment Lines. Select multiple Shipment lines that you want to include in the invoice and choose the OK button. In Line section, You can see the added sales shipment lines. To post the invoice, choose the Post    

Introduction: In Dynamics 365 Business central, an item can be marked as blocked for sales, blocked for purchase and you can block it from being posted in any transaction. Block inventory items for sales: Choose the search icon, enter Items, and then choose the related link. Select the item that you want to block, and then choose the Edit action. To block the selected item for sales transactions, on the Price & Sales Fast Tab, select the Sale blocked check box. If you try to enter the item on a sales document or journal line, you will now get an error message that the item is blocked. Block inventory items for sales: Choose the search icon, enter Items, and then choose the related link. Select the item that you want to block, and then choose the Edit action. To block an item for purchase transactions, on the Replenishment Fast Tab, select the Purchase blocked check box. If you try to enter the item on a purchase document or journal line, you will now get an error message that the item is blocked. Block inventory items for transaction: Choose the search icon, enter Items, and then choose the related link. Select the item that you want to block, and then choose the Edit action. To block an item for transactions, on the Item Fast Tab, select the blocked check box. If you try to enter the item on a purchase document or journal line, you will now get an error message that the item is blocked.